Syntax:
CreateODBCDateTime(dateexpr)
Description:
In order to use dates in a SQL language query, the date must be formatted
properly. CreateODBCDateTime
converts a BASIC datetime type to a string of text that is valid for use
in a SQL Query through ODBC or OLEDB.
Parameter Description
dateexpr A valid data + time type or variant that can be converted to a date + time value
Example:
Sub
Main
myodbcdatetime = CreateOdbcDateTime(Now())
'is the same as
myodbcdatetime = CreateOdbcDateTime(Date()
+ Time())
End Sub
See Also: